import xlwings as xw
app = xw.App(visible=False, add_book=False)
workbook1 = app.books.open('F:\\python\\第3章\\供应商信息表.xlsx')
workbook2 = app.books.open('F:\\python\\第3章\\汽车备案信息.xlsx')
worksheet1 = workbook1.sheets[0]
worksheet2 = workbook2.sheets['汽车备案信息']
worksheet1.copy(before=worksheet2)
workbook2.save('F:\\python\\第3章\\汽车信息表.xlsx')
workbook1.close()
workbook2.close()
app.quit()
